from django.contrib.gis.db import models

class Bluezone(models.Model):
    gid = models.IntegerField(primary_key=True)
    objectid = models.IntegerField()
    recno = models.DecimalField(max_digits=65535, decimal_places=65535)
    street = models.CharField(max_length=20)
    date_chk = models.DateField()
    x_street = models.CharField(max_length=15)
    location = models.CharField(max_length=50)
    street_add = models.CharField(max_length=30)
    firm = models.CharField(max_length=30)
    length = models.DecimalField(max_digits=65535, decimal_places=65535)
    side = models.CharField(max_length=3)
    curb = models.CharField(max_length=5)
    sign = models.CharField(max_length=5)
    corrt_add = models.IntegerField()
    the_geom = models.PointField(srid=2227)
    geom_4326 = models.PointField(srid=4326)
    objects = models.GeoManager()
    class Meta:
        db_table = u'bluezones'


class Incident(models.Model):
    gid = models.IntegerField(primary_key=True)
    incidntnum = models.CharField(max_length=9)
    category = models.CharField(max_length=35)
    descript = models.CharField(max_length=60)
    dayofweek = models.CharField(max_length=16)
    date = models.CharField(max_length=10)
    time = models.CharField(max_length=5)
    pddistrict = models.CharField(max_length=16)
    resolution = models.CharField(max_length=45)
    location = models.CharField(max_length=60)
    the_geom = models.PointField(srid=2227)
    geom_4326 = models.PointField(srid=4326)
    objects = models.GeoManager()
    class Meta:
        db_table = u'sfpd_incident_2009'

